package com.wms.wms.mapper;

import com.wms.wms.entity.Existing;
import com.wms.wms.entity.OutStock;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Component;

import java.sql.Date;
import java.util.ArrayList;

@Component
@Mapper
public interface ExistingMapper {
    Integer queryOutOfDateByParam(@Param("id") String id, @Param("e") Date e);
    Integer queryInventoryByParam(@Param("id") String id);
    Integer queryTotalInventory();

    ArrayList<Existing> queryByIdAndDate(@Param("id") String id, @Param("b") Date b, @Param("e") Date e);

    ArrayList<Existing> queryByDate(@Param("b") Date b,@Param("e") Date e);

}